﻿
IF (EXISTS(SELECT id from sysobjects where id=object_id('usp_UpdateVoter')))
	DROP PROCEDURE [dbo].[usp_UpdateVoter]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




create procedure usp_UpdateVoter
@WardId  as nvarchar(50),
@VoterId  as nvarchar(50),
@Name  as nvarchar(50),
@FatherName  as nvarchar(50),
@DateOfBirth  as datetime,
@Address  as nvarchar(50),
@EmailId  as nvarchar(50),
@DistrictId as nvarchar(50),
@PanchayatId as nvarchar(50)

as

update TBLVOTER 
set 
DistrictId = @DistrictId,
PanchayatId = @PanchayatId,
WardId = @WardId,
NAME= @Name,
FATHERNAME = @FatherName,
DateOfBirth = @DateOfBirth,
Address =@Address,
EmailId = @EmailId 
where
VOTERID = @VoterId